Owner

dbo

Creation Date

10-07-2003 10:31:36

Remarks

Columns

Name	Type	Length	IsNullable	Collation
CategoryName	nvarchar	30		SQL_Latin1_General_CP1_CI_AS
CategoryName	sysname	30		SQL_Latin1_General_CP1_CI_AS
ProductName	nvarchar	80		SQL_Latin1_General_CP1_CI_AS
ProductName	sysname	80		SQL_Latin1_General_CP1_CI_AS
QuantityPerUnit	nvarchar	40		SQL_Latin1_General_CP1_CI_AS
QuantityPerUnit	sysname	40		SQL_Latin1_General_CP1_CI_AS
UnitsInStock	smallint	2
Discontinued	bit	1

View Definition

create view "Products by Category" AS
SELECT Categories.CategoryName, Products.ProductName, Products.QuantityPerUnit, Products.UnitsInStock, Products.Discontinued
FROM Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID
WHERE Products.Discontinued <> 1
--ORDER BY Categories.CategoryName, Products.ProductName